Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | Transaction(TR_TRN) |
WorkstationID (FK)(PK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | WorkstationRuleApplication(CO_APLN_WS_RU) |
WorkstationRuleTypeCode (FK)(PK) | A code that refers to a specific WORKSTATION RULE type. | TY_RU_WS | Code2 | char(2) | WorkstationRuleApplication(CO_APLN_WS_RU) |
WorkstationRuleNumber (FK)(PK) | A reference number for a specific WORKSTATION RULE. | ID_RU_WS | Identity | integer | WorkstationRuleApplication(CO_APLN_WS_RU) |
WorkstationGroupID (FK)(PK) | A unique identifier for a group of WORKSTATIONs. This could refer to the WORKSTATIONs at the checkout, delicatessen, customer service or in the goods receiving area of the store. | ID_GP_WS | Identity | integer | WorkstationRuleApplication(CO_APLN_WS_RU) |
OperatorID | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | |
OverrideFlag | A flag to signify that a certain limit has been overriden. | FL_OVRD_WS_RU | Flag | integer | |